package com.googlecode.projects.tests;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

/**
 * Example 3.1.
 */
public class JDBCSelect {
	public static void main(String args[]) {
		String url = "jdbc:derby:/DerbyDB/AssetDB";
		Connection con = null;

		try {
			String driver = "org.apache.derby.jdbc.EmbeddedDriver";

			Class.forName(driver).newInstance();
		} catch (Exception e) {
			System.out.println("Failed to load mSQL driver.");
			return;
		}
		try {
			con = DriverManager.getConnection(url);
			Statement select = con.createStatement();
			ResultSet result = queryDatabase(select);

			while (result.next()) { // process results one row at a time
				String val = result.getString(2);
				System.out.println(val);
			}

		} catch (Exception e) {
			e.printStackTrace();
		} finally {
			if (con != null) {
				try {
					con.close();
				} catch (Exception e) {
					e.printStackTrace();
				}
			}
		}
	}

	/**
	 * @param select
	 * @return
	 * @throws SQLException
	 */
	public static ResultSet queryDatabase(Statement select) throws SQLException {
		ResultSet result = select
				.executeQuery("SELECT * FROM REQUESTSFROM WHERE PERSON LIKE '192.168.1.2'");
		return result;
	}
}
